You are here:

Work Item Snapshot Monthly

Work Item Snapshot Monthly iCube enables you to create ad hoc reports that help you analyze the flow of work items as it progresses through various status categories. Using this dossier, you can chart a month-wise average age report. You can view a snapshot of historical data from the past six months.

Attributes

Expand this link to view the list of attributes available as part of the Work Item Snapshot Monthly iCube.

Attributes	Description
Assigned To	User responsible for working on the Work Item
Calendar Month	Gregorian calendar month displayed in the format 'Mon YYYY'
Cancelled DateTime	Date and time when the work item was cancelled
Completed DateTime	Date and time when the work item was completed
Created DateTime	Date and time at which the Work Item was created
Date	Date on which the status of the Work Item moved to 'Created', 'In Progress', 'Resolved', or 'Completed'
Due Date	Date by when the Work Item is scheduled for completion
Earliest Fix Version	Version to which the selected work item is associated as 'Fix Version'
In Progress DateTime	Date and time at which the Work Item first moved to the 'In Progress' status category
In Progress Flag	Indicates whether the Work Item is currently in the 'In Progress' status category
Last Iteration	The last sprint (iteration) to which the work item is associated with
Last Updated DateTime	Date and time at which the work item was last updated
Overdue Flag	Indicates whether the Work Item is overdue (Current date is past the due date and the status category is less than 'Resolved')
Priority	Priority of the Work Item
Project	Project to which the Work Item is associated
Proposed Flag	Indicates whether the Work Item is currently in the 'Proposed' status category
Reassignment Count	Count of the number of times a work item was reassigned
Reopen Count	Count of the number of times a work item was reopened
Reopened Flag	Indicates whether the Work Item has ever been reopened
Resolved DateTime	Date and time at which the Work Item was last Resolved
Status (Source)	Status of the work item as mentioned in the source
Status (Standardized)	Status of the work item
Summary	Title or brief summary about the Work Item
Work Item	Work Item refers to an issue that represents work to be completed. Work items can be of various types, such as task, enhancement, bug, epic, and so on
Work Item Number	Unique identifier for the Work Item

Metrics

Expand this link to view the list of metrics available as part of the Work Item Snapshot Monthly iCube.

Metric Name	Description	Formula	Expected Value
Avg of Age Since Creation (Days)	Average age of the work item in days	[Age Since Creation Monthly] / ([Created Work Items - Monthly] * 86400.0)	>0
Backlog Business Monthly Value		Sum ([Business Value_Monthly Snapshot])<[Work Item Snapshot Backlog Flag]	>0
Backlog Monthly Snapshot	Count of Work Items in Backlog for that month	Count([Created Work Items - Monthly])<[Work Item Snapshot Backlog Flag]	>0
Backlog Story Points Monthly	Sum of story points for all the Work Items in Backlog for that month	Sum([Story Points_Monthly Snapshot])<[Work Item Snapshot Backlog Flag]	>0
Business Value	Business value of a work item calculated on certain pre-defined parameters	Max([Business Value_Monthly Snapshot])	>0
Completed Business Value Monthly	Sum of Business Value for all the Work Items completed in that month	Sum([Business Value_Monthly Snapshot])<[Work Item Is Completed Period Flag]	>0
Completed Story Points Monthly	Sum of story points for all the Work Items completed in that month	Sum([Story Points_Monthly Snapshot])<[Work Item Is Completed Period Flag]	>0
Completed Work Items - Monthly Snapshot	Count of all the Work Items completed in that month	Count([Created Work Items - Monthly])<[Work Item Is Completed Period Flag]	>0
Cumulative Completed Business Value Monthly	Sum of Business Value for all the Work Items completed till that month	Sum([Business Value_Monthly Snapshot])<[Work Item Cumulative Completed Flag]	>0
Cumulative Completed Monthly Snapshot	Count of all the Work Items completed till that month	Count([Created Work Items - Monthly])<[Work Item Cumulative Completed Flag]	>0
Cumulative Completed Story Points Monthly	Sum of story points for all the Work Items completed till that month	Sum([Story Points_Monthly Snapshot])<[Work Item Cumulative Completed Flag]	>0
In Progress Work Items	Work Item which are in In Progress state	Count([Created Work Items - Monthly]) where inprogress_flag = ‘Y’	>=0
Max of Age Since Creation (Days)	Maximum time for which the Work Item was Created	Max(([Age Since Creation Monthly] / 86400.0))	>=0
Min of Age Since Creation (Days)	Minimum time for which the Work Item was Created	Min(([Age Since Creation Monthly] / 86400.0))	>=0
Proposed Work Items	Count of all work items whose current status category is "Proposed"	Count (Created Work Items) WHERE Work Item Proposed Flag (ID) = 'Y'	0 or >0
Reopened Work Items Backlog	Total number of work items that have been reopened (Status category changes from "Resolved" or "Closed" to an earlier status)	Sum [Reopened Count] Where Reopened Flag (ID) = Y	Closer to 0 is ideal
Story Points	Story points assigned to the work item	Sum (Story Points)	>0